import openpyxl

myBook=openpyxl.load_workbook('成绩表.xlsx')
mySheet=myBook.active

mySet=set(list(mySheet.values)[1:])
# 从集合中随机删除一个成员
mySet.pop()
while mySheet.max_row>1:
	mySheet.delete_rows(2)
for myRow in mySet:
	mySheet.append(myRow)

myBook.save('结果表-成绩表.xlsx')